How to // Comment
Connect Excel to Coinmarketcap API // Connectez Excel à l'API Coinmarketcap

Windows

[Windows] Connect Excel to Coinmarketcap API



0. Obtaining a Coinmarketcap API Key
https://pro.coinmarketcap.com/v
1. Connecting Excel to the Coinmarketcap API
  • Ribbon > "Data" > "From Other Sources" > "From Web"
2. Select Advanced
3. Enter the following URL
https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest
4. Fill "HTTP request header parameters"
X-CMC_PRO_API_KEY _YOUR_PRO_CMC_KEY_
5. Change the request with what you want
For exemple, if you want to get BTC, ETH, FLIXX, EGLD, CRO, KCS, CHSB, PMON, POTS, SCV lastest prices and convert them in EUR
6. Click on time on "data"
7. Next expand the records by clicking on the column header, and select the columns you want to import, so only "quota" and deselect "Use original column name as prefix"
8. Do the same to be able to select "price"
9. Ribbon > "Close and Load to load the data as a table in Excel"
10. Ribbon > Connection Properties
  • Uncheck "Enable background refresh"
  • Uncheck "Refresh every"
  • Check "Refresh data when opening the file"
  • Uncheck "Remove data from the external data range before saving the workbook"
  • Check "Refresh this connection on Refresh All"
11. You must select the cells that you want to freeze, then copy and paste them in special mode 123 (number) which will remove the link with the values ​​which are refreshed, while leaving the values
  • If necessary, remember to duplicate the cells before, so as not to lose the formulas

How to

[How to] Connectez Excel à l'API Coinmarketcap